create external table jms_dm.dm_no_operate_site_num 
(
date_time string COMMENT '查询日期' ,
site_name string COMMENT '网点名称' ,
site_code string COMMENT '网点code' ,
agent_name string COMMENT '代理区名称' ,
agent_code string COMMENT '代理区code' ,
is_operate  string COMMENT '是否运营，1是，0否',
create_time timestamp COMMENT '网点创建时间'
)
comment '未运营网点数'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_no_operate_site_num'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
